TermRegistrationSetting

EntityType | Dependent
Logical Entity Name | TermRegistrationSetting
Default Table Name | AdTermOnLineRegistration
Logical Only | NO
Owner | dbo
Definition |
Note |

TermRegistrationSetting Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
TermId |  | INTEGER | NO |
CampusId |  | INTEGER | NO |
PreRegistrationAvailableDate |  | DATETIME | YES |
ClassSectionScheduleAvailableDate |  | DATETIME | YES |
ClassSectionScheduleUnavailableDate |  | DATETIME | YES |
OnlineDescription |  | VARCHAR(60) | YES |
WaitlistMaximumCredits |  | NUMERIC(9, 2) | YES |
IsReservationAllowed |  | BIT | NO |
ReservationMaximumCredits |  | NUMERIC(9, 2) | YES |
ReservationExpirationMinutes |  | INTEGER | YES |
ReservationConfirmMinutes |  | INTEGER | YES |
IsUnregistrationAllowed |  | BIT | NO |
IsDropAllowed |  | BIT | NO |
MinimumCredits |  | NUMERIC(9, 0) | YES |
MaximumCredits |  | NUMERIC(9, 0) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
IsInvoiceShown |  | BIT | NO |
IsPaymentAllowed |  | BIT | NO |
IsBillingSummaryShown |  | BIT | NO |
IsFundingShown |  | BIT | NO |
GradesAvailableDate |  | DATETIME | YES |
IsWaitlistingAllowed |  | BIT | NO |
RegistrationStartDate |  | DATETIME | YES |
RegistrationEndDate |  | DATETIME | YES |
CourseSharingStartDateTime |  | DATETIME | YES |
CourseSharingEndDateTime |  | DATETIME | YES |
IsAuditClassAllowed |  | BIT | YES |
AuditMaximumCredits |  | NUMERIC(5, 0) | YES |
AddClassEndDate |  | DATETIME | YES |
DropClassEndDate |  | DATETIME | YES |
TermId |  | INTEGER | YES |

TermRegistrationSetting Keys

Key Name | Key Type | Keys
AdTermOnLineRegistration_AdTermID_SyCampusID_U_C_IDX | PrimaryKey | TermId, CampusId
AdTermOnLineRegistration_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId
AdTermOnLineRegistration_SyCampusId_AdTermId_CourseSharingStartDate_U_N_IDX | Alternate Key | CampusId, TermId, CourseSharingStartDateTime

TermRegistrationSetting Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Term | Non-Identifying | One To Zero or More |  |  |  | TermId | NO
Campus | Identifying | One To Zero or More |  |  |  | CampusId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

TermRegistrationSetting Check Constraints

Check Constraint Name | CheckConstraint

TermRegistrationSetting Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.TermRegistrationSetting | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdTermOnLineRegistration | NO |  |  |

TermRegistrationSetting Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Logical | CourseRegistration
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

TermRegistrationSetting Data Movement Rules

Name | Type | Rule Text/Value